CREATE OR REPLACE VIEW cv$_map_all_v
AS
SELECT s.id AS source_id,
			s.source_schema_name,
			s.source_table_name,
			s.pk_col_names AS source_pk_col_names,
			s.change_table_schema,
			s.change_table_name,
			s.change_set_name,
			s.subscription_handle,
			s.subscription_schema_name,
			s.subscription_name,
			s.view_name,
			s.serial_num AS source_serial_num,
			s.capture_col_names,
			s.capture_values,
			s.source_colmap,
			s.condition,
			t.id AS target_id,
			t.owner AS target_owner,
			t.name AS target_name,
			t.map_package_owner,
			t.map_package_name,
			t.last_refresh_type,
			t.last_refresh_date,
			t.parent_id AS target_parent_id,
			t.logical_type AS target_logical_type,
			t.is_virtual AS target_is_virtual
	FROM cv$_source s, cv$_map m, cv$_target t
	WHERE s.id = m.source_id
		AND t.id = m.target_id;